package com.ndood.api.base.dao.extend.record.receive.v1;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.ndood.api.domain.record.receive.v1.entity.dto.RecoRecPayDto;

@Mapper
public interface ExtendRecoRecPayDao {

	/**
	 * 1 根据订单号查询出订单支付信息
	 */
	@Select("SELECT "
			+ "`pay_order_no`, `order_no`, `pay_way`, `pay_type`, `contract_id`, `contract_type`, `contract_no`, "
			+ "`contract_name`, `product_no`, `product_name`, `channel_id`, `channel_no`, `channel_name`, "
			+ "`total_amount`, `free_amount`, `receipt_amount`, `third_free_amount`, `buyer_pay_amount`, "
			+ "`pay_time`, `status`, `param1`, `param2`, `param3`, `param4`, `param5`, `param6`, `create_time`, `update_time`"
			+ "FROM r_rec_pay "
			+ "WHERE `pay_order_no` = #{payOrderNo} ")
	public RecoRecPayDto extendFindOfflinePayByPayOrderNo(@Param("payOrderNo") String payOrderNo);
}
